
local indata LAD\Data
local infile LAD\Data_Cleaning

use "`indata'\LAD_Crowdout.dta", clear

do "`infile'\LAD_Commands_filtering.do"

keep if dues>0

replace empinc=empinc+cqppympe

local sample1 penadj>0
local sample2 penadj==0
foreach i of numlist 1/2 {
	summarize age if `sample`i''
	summarize yob if `sample`i''
	summarize female if `sample`i''
	summarize married if `sample`i''

	summarize empinc_flag if `sample`i''
	summarize selfempinc_flag if `sample`i''
	summarize union_flag if `sample`i''
	summarize eiinc_flag if `sample`i''

	summarize empinc if empinc!=0 & `sample`i'', detail
	summarize selfempinc if selfempinc!=0 & `sample`i'', detail
	summarize othinc if othinc!=0 & `sample`i'', detail
	summarize ttlinc if ttlinc!=0 & `sample`i'', detail

	summarize penadj_flag if `sample`i''
	summarize rppcont_flag if `sample`i''
	summarize rspcont_flag if `sample`i''
	summarize rspwd_flag if `sample`i''
	summarize unused_flag if `sample`i''

	summarize penadj if penadj!=0 & `sample`i'', detail
	summarize rppcont if rppcont!=0 & `sample`i'', detail
	summarize rspcont if rspcont!=0 & `sample`i'', detail
	summarize rspwd if rspwd!=0 & `sample`i'', detail
	summarize unused if unused!=0 & `sample`i'', detail
	
	summarize saving if saving!=0 & `sample`i'', detail
	summarize saverate if saverate!=0 & `sample`i'', detail
}

exit